/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package com.mycompany.h2test1;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.logging.Level;
import java.util.logging.Logger;

/**
 *
 * @author JSJSYS
 */
public class install {
     static final String DRIVER_CLASS = "org.h2.Driver";
    //数据库连接URL，当前连接的是E:/H2目录下的mydb数据库
   // static final String JDBC_URL = "jdbc:h2:E:/H23/mydb";
      static final String JDBC_URL = "jdbc:h2:tcp://localhost/c:/h2/datas/test";
     // static final String JDBC_URL = "jdbc:h2:tcp://localhost/mem:mydb";
    //用户名
     static final String USER = "sa";
    //密码
     static final String PASSWORD = "123456";
    
 private static int num =1;
    private static int getId(){
        return num++  ;
    }
public static void main(String args[]){
   try{
       Class.forName(DRIVER_CLASS);
        // 根据连接URL，用户名，密码获取数据库连接
       // 创建一个Statement
       try (Connection conn = DriverManager.getConnection(JDBC_URL, USER, PASSWORD)) {
           // 创建一个Statement
           Statement stmt = conn.createStatement();
           //如果存在表就先删除
           stmt.execute("DROP TABLE IF EXISTS stu_info");
           //创建stu_info表
           stmt.execute("CREATE TABLE stu_info(id VARCHAR(36) PRIMARY KEY,name VARCHAR(100),sex VARCHAR(4),student_id VARCHAR(50))");
           //新增4 条
           stmt.executeUpdate("INSERT INTO stu_info VALUES('" + getId() + "','程凌霄','男','20151101066')");
           stmt.executeUpdate("INSERT INTO stu_info VALUES('" + getId() + "','陈秋云','女','20151101026')");
           stmt.executeUpdate("INSERT INTO stu_info VALUES('" + getId() + "','黍路','女','20151101056')");
           stmt.executeUpdate("INSERT INTO stu_info VALUES('" + getId() + "','田梦','女','20151101096')");
           p("++++++++++++++++++++++++++++++++++++++显示刚保存的四条数据：");
           show(stmt);
           p("");
           p("");
           p("");
           //删除 陈秋云
           stmt.executeUpdate("DELETE FROM stu_info WHERE name='陈秋云'");
           p("++++++++++++++++++++++++++++++++++++++删除 陈秋云 后，显示结果：");
           show(stmt);
           p("");
           p("");
           //修改 黍路 === >黎路
           stmt.executeUpdate("UPDATE stu_info SET name='黎路' WHERE name='黍路'");
           p("=+++++++++++++++++++++++++++++++++修改 黍路 === >黎路,显示结果：");
           show(stmt);
           //释放stmt
           stmt.close();
           //关闭连接
       }
        System.out.println("------jdbc -end!!!------");

    }catch (SQLException ex)  {
        Logger.getLogger(h2test.class.getName()).log(Level.SEVERE,null,ex);
        
    }catch(ClassNotFoundException  ex){
     Logger.getLogger(h2test.class.getName()).log(Level.SEVERE,null,ex);
    }catch(Exception  ex){
         Logger.getLogger(h2test.class.getName()).log(Level.SEVERE,null,ex);
    }finally{
      p("end!!!!!");
   }
}

    private static void p(String 显示刚保存的四条数据) {
        throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.
    }

    private static void show(Statement stmt) {
        throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.
    }
}